Object Query Language
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
top
Object Query Language est une extension du langage SQL pour base de donnΓ©es orientΓ©e objet, langage de requΓͺte utilisΓ© pour interroger des SGBDO, normalisΓ© par l'ODMGcite-ref-1[1].
Ce langage est typΓ© (les requΓͺtes retournent des objets), et utilise les rΓ¨gles du polymorphisme.
Contents
β’ Exemple
β’ RΓ©fΓ©rences
β’ Voir aussi
ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
Exemple
Moyenne de la capacitΓ© de la RAM des PC de la base, par constructeur :
SELECT manufacturer, AVG(SELECT part.pc.ram FROM partition part)
FROM PCs pc
GROUP BY manufacturer: pc.manufacturer;
RΓ©fΓ©rences
cite-note-11. β by-r-g-g-cattell-douglas-k-barry-mark-berler-jeff-eastman-david-jordan-craig-russell-olaf-schadow-torsten-stanienda-and-fernando-velez2000edited-by-r-g-g-cattell-douglas-k-barry-mark-berler-jeff-eastman-david-jordan-craig-russell-olaf-schadow-torsten-stanienda-and-fernando-velez2000(en) Edited by R. G.G. Cattell, Douglas K. Barry, Mark Berler, Jeff Eastman,David Jordan, Craig Russell, Olaf Schadow, Torsten Stanienda, and Fernando Velez, The Object Data Management Standard: ODMG 3.0, Morgan Kaufmann, 2000 (ISBN 1-55860-647-5)
Voir aussi
β’ Object Definition Language (ja)
β’ Portail de la programmation informatique
β’ Portail des bases de donnΓ©es